﻿CREATE TABLE [dbo].[UserProfiles] (
    [UserProfileID]                INT            NOT NULL,
    [Name]                         NVARCHAR (100) NULL,
    [FirstName]                    NVARCHAR (50)  NULL,
    [LastName]                     NVARCHAR (50)  NULL,
    [Birthday]                     DATETIME       NULL,
    [Gender]                       BIT            NULL,
    [Age]                          INT            NULL,
    [CurrentWeight]                FLOAT          NULL,
    [Link]                         NVARCHAR (500) NULL,
    [Timezone]                     FLOAT          NULL,
    [Height]                       FLOAT          NULL,
    [TotalCalorieLostGainPerDay]   FLOAT          NULL,
    [TotalCalorieLoseGainPerMonth] FLOAT          NULL,
    [BMI]                          FLOAT          NULL,
    [WeightCategoryID]             INT            NULL,
    [BMR]                          FLOAT          NULL,
    [ActivityLevelID]              INT            NULL,
    [HealthRatingID]               INT            NULL,
    [TotalCalorieNeedPerDay]       INT            NULL,
    [TargetWeight]                 FLOAT          NULL,
    [DateTimeAdded]                DATETIME       NOT NULL,
    [DateTimeUpdated]              DATETIME       NOT NULL,
    [LocationID]                   INT            NULL
);

